package com.truongnha.clienttn.data.dao;

import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

public class StudentScheme {
	public static final String TABLE_NAME = "Student";
	public static final String ID = "id";
	public static final String PHONE = "phone";
	public static final String EMAIL = "email";
	public static final String SMS_PHONE = "sms_phone";
	public static final String FIRST_NAME = "first_name";
	public static final String LAST_NAME = "last_name";
	public static final String BIRTHDAY = "birthday";
	public static final String STUDENT_ID = "student_id";
	public static final String SEX = "sex";
	
	
	
	private static final String DATABASE_CREATE = "create table "
			+ TABLE_NAME + "(" + ID + " integer primary key ," 
			+ PHONE + " text," 
			+ EMAIL + " text, " 
			+ SMS_PHONE + " text," 
			+ FIRST_NAME + " text, " 
			+ LAST_NAME + " text, " 
			+ BIRTHDAY + " text, " 
			+ STUDENT_ID + " integer primary key, " 
			+ SEX + " text, " 
			+ " );";

	// private static final String QUERY_TABLE_DROP = "DROP TABLE IF EXISTS " +
	// TABLE_AREA_NAME;
	public static void onCreate(SQLiteDatabase db) {
		Log.i("LOG", "on Create account table");
		db.execSQL(DATABASE_CREATE);

	}
}
